Module 7 - Working with Databases and SQL

Learning Objectives

• Working with multiple dataframes, Joins and Keys
• Relational Database basics: design and tradeoffs
• Working with R and SQL
• Basic database normalization

Readings

• RDS (R for Data Science): Chapters 18-21

Additional Resources:

• SQL Cheat Sheet
• Practical SQL: A Beginner’s Guide to Storytelling with Data. Anthony DeBarros. No Start Press (2022)
• SQL for Data Scientists. Renee Teate. Wiley.
• duckdb page and SQL intro

Videos

Mother Duck tutorial